<!doctype html>
<html class="no-js" lang="en">
<head>
    <meta name="viewport" content="width=device-width, initial-scale=1" charset="UTF-8">
    <title>org.jetbrains.exposed.v1.jdbc</title>
<link href="../../images/logo-icon.svg" rel="icon" type="image/svg"><script>var pathToRoot = "../../";</script>
    <script>document.documentElement.classList.replace("no-js", "js");</script>
    <script>const storage = localStorage.getItem("dokka-dark-mode")
      if (storage == null) {
        const osDarkSchemePreferred = window.matchMedia && window.matchMedia('(prefers-color-scheme: dark)').matches
        if (osDarkSchemePreferred === true) {
          document.getElementsByTagName("html")[0].classList.add("theme-dark")
        }
      } else {
        const savedDarkMode = JSON.parse(storage)
        if (savedDarkMode === true) {
          document.getElementsByTagName("html")[0].classList.add("theme-dark")
        }
      }
    </script>
<script type="text/javascript" src="https://unpkg.com/kotlin-playground@1/dist/playground.min.js" async></script>
<script type="text/javascript" src="../../scripts/sourceset_dependencies.js" async></script>
<link href="../../styles/style.css" rel="Stylesheet">
<link href="../../styles/main.css" rel="Stylesheet">
<link href="../../styles/prism.css" rel="Stylesheet">
<link href="../../styles/logo-styles.css" rel="Stylesheet">
<link href="../../ui-kit/ui-kit.min.css" rel="Stylesheet">
<script type="text/javascript" src="../../scripts/safe-local-storage_blocking.js"></script>
<script type="text/javascript" src="../../scripts/navigation-loader.js" async></script>
<script type="text/javascript" src="../../scripts/platform-content-handler.js" async></script>
<script type="text/javascript" src="../../scripts/main.js" defer></script>
<script type="text/javascript" src="../../scripts/prism.js" async></script>
<script type="text/javascript" src="../../ui-kit/ui-kit.min.js" defer></script></head>
<body>
<div class="root">
    <header class="navigation theme-dark" id="navigation-wrapper" role="banner">
<a class="library-name--link" href="../../index.html" tabindex="1">
                    exposed
            </a>        <button class="navigation-controls--btn navigation-controls--btn_toc ui-kit_mobile-only" id="toc-toggle" type="button">Toggle table of contents
        </button>
        <div class="navigation-controls--break ui-kit_mobile-only"></div>
        <div class="library-version" id="library-version">1.0.0-rc-4
        </div>
        <div class="navigation-controls">
        <ul class="filter-section filter-section_loading" id="filter-section" aria-label="Target filter">
                <button class="platform-tag platform-selector jvm-like" data-active="" aria-pressed="true" data-filter=":exposed-jdbc/main">jvm</button>
            <div class="dropdown filter-section--dropdown" data-role="dropdown" id="filter-section-dropdown">
                <button class="button button_dropdown filter-section--dropdown-toggle" role="combobox" data-role="dropdown-toggle" aria-controls="platform-tags-listbox" aria-haspopup="listbox" aria-expanded="false" aria-label="Toggle source sets"></button>
                <ul role="listbox" id="platform-tags-listbox" class="dropdown--list" data-role="dropdown-listbox" aria-label="Target filter">
                    <div class="dropdown--header"><span>Target filter</span>
                        <button class="button" data-role="dropdown-toggle" aria-label="Close target filter">
                            <i class="ui-kit-icon ui-kit-icon_cross"></i>
                        </button>
                    </div>
                        <li role="option" class="dropdown--option platform-selector-option jvm-like" tabindex="0">
                            <label class="checkbox">
                                <input type="checkbox" class="checkbox--input" id=":exposed-jdbc/main" data-filter=":exposed-jdbc/main">
                                <span class="checkbox--icon"></span>
                                jvm
                            </label>
                        </li>
                </ul>
                <div class="dropdown--overlay"></div>
            </div>
        </ul>
            <button class="navigation-controls--btn navigation-controls--btn_theme" id="theme-toggle-button" type="button">Switch theme
            </button>
            <div class="navigation-controls--btn navigation-controls--btn_search" id="searchBar" role="button">Search in
                API
            </div>
        </div>
    </header>
    <div id="container">
        <nav id="leftColumn" class="sidebar" data-item-type="SECTION" data-item-config="{&quot;defaultSize&quot;: 280, &quot;minSize&quot;: 200, &quot;maxSize&quot;: 400}">
            <a class="toc--skip-link" href="#main">Skip to content</a>
            <div class="dropdown theme-dark_mobile" data-role="dropdown" id="toc-dropdown">
                <ul role="listbox" id="toc-listbox" class="dropdown--list dropdown--list_toc-list" data-role="dropdown-listbox" aria-label="Table of contents">
                    <div class="dropdown--header">
                            <span>
                                    exposed
                            </span>
                        <button class="button" data-role="dropdown-toggle" aria-label="Close table of contents">
                            <i class="ui-kit-icon ui-kit-icon_cross"></i>
                        </button>
                    </div>
                    <div class="sidebar--inner" id="sideMenu"></div>
                </ul>
                <div class="dropdown--overlay"></div>
            </div>
        </nav>
        <div id="resizer" class="resizer" data-item-type="BAR"></div>
        <div id="main" data-item-type="SECTION" role="main">
<div class="main-content" data-page-type="package" id="content" pageids="exposed-jdbc::org.jetbrains.exposed.v1.jdbc////PointingToDeclaration//-1624674168">
  <div class="breadcrumbs"><a href="../index.html">exposed-jdbc</a><span class="delimiter">/</span><span class="current">org.jetbrains.exposed.v1.jdbc</span></div>
  <div class="cover ">
    <h1 class="cover"><span><span>Package-level</span></span> <span><span>declarations</span></span></h1>
  </div>
  <div class="tabbedcontent">
    <div class="tabs-section" tabs-section="tabs-section"><button class="section-tab" data-active="" data-togglable="TYPE">Types</button><button class="section-tab" data-togglable="FUNCTION,EXTENSION_FUNCTION">Functions</button><button class="section-tab" data-togglable="PROPERTY,EXTENSION_PROPERTY">Properties</button></div>
    <div class="tabs-section-body">
      <div data-togglable="TYPE">
        <h2 class="tableheader">Types</h2>
        <div class="table"><a data-name="-145810811%2FClasslikes%2F-1624674168" anchor-label="Database" id="-145810811%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-database/index.html"><span><span>Database</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-145810811%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-database/index.html">Database</a> : <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-database-api/index.html">DatabaseApi</a></div><div class="brief "><p class="paragraph">Class representing the underlying JDBC database to which connections are made and on which transaction tasks are performed.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1071440159%2FClasslikes%2F-1624674168" anchor-label="DatabaseConnectionAutoRegistration" id="1071440159%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-database-connection-auto-registration/index.html"><span>Database</span><wbr><span>Connection</span><wbr><span>Auto</span><wbr><span><span>Registration</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1071440159%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">interface </span><a href="-database-connection-auto-registration/index.html">DatabaseConnectionAutoRegistration</a> : <a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-function1/index.html">Function1</a><span class="token operator">&lt;</span><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.sql/java/sql/Connection.html">Connection</a><span class="token punctuation">, </span><a href="../org.jetbrains.exposed.v1.jdbc.statements.api/-exposed-connection/index.html">ExposedConnection</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Represents an <a href="../org.jetbrains.exposed.v1.jdbc.statements.api/-exposed-connection/index.html">ExposedConnection</a> that is loaded whenever a connection is accessed by a <a href="-database/index.html">Database</a> instance.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-614176744%2FClasslikes%2F-1624674168" anchor-label="EmptySizedIterable" id="-614176744%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-empty-sized-iterable/index.html"><span>Empty</span><wbr><span>Sized</span><wbr><span><span>Iterable</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-614176744%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-empty-sized-iterable/index.html">EmptySizedIterable</a><span class="token operator">&lt;</span><span class="token keyword">out </span><a href="-empty-sized-iterable/index.html">T</a><span class="token operator">&gt;</span> : <a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="-empty-sized-iterable/index.html">T</a><span class="token operator">&gt; </span>, <a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-iterator/index.html">Iterator</a><span class="token operator">&lt;</span><a href="-empty-sized-iterable/index.html">T</a><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Represents a <a href="-sized-iterable/index.html">SizedIterable</a> that is empty and cannot be iterated over.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="2101240935%2FClasslikes%2F-1624674168" anchor-label="Except" id="2101240935%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-except/index.html"><span><span>Except</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="2101240935%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-except/index.html">Except</a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">firstStatement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">secondStatement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span> : <a href="-set-operation/index.html">SetOperation</a></div><div class="brief "><p class="paragraph">Represents an SQL operation that returns the distinct results of <a href="../../exposed-jdbc/org.jetbrains.exposed.v1.jdbc/-except/--root--.html">firstStatement</a> that are not common to <a href="../../exposed-jdbc/org.jetbrains.exposed.v1.jdbc/-except/--root--.html">secondStatement</a>.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-828402260%2FClasslikes%2F-1624674168" anchor-label="ExplainBlockingExecutable" id="-828402260%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-explain-blocking-executable/index.html"><span>Explain</span><wbr><span>Blocking</span><wbr><span><span>Executable</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-828402260%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">class </span><a href="-explain-blocking-executable/index.html">ExplainBlockingExecutable</a><span class="token punctuation">(</span><span class="parameters "><span class="parameter "><span class="token keyword">val </span>statement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-explain-query/index.html">ExplainQuery</a></span></span><span class="token punctuation">)</span> : <a href="../org.jetbrains.exposed.v1.jdbc.statements/-blocking-executable/index.html">BlockingExecutable</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements.api/-result-api/index.html">ResultApi</a><span class="token punctuation">, </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-explain-query/index.html">ExplainQuery</a><span class="token operator">&gt; </span>, <a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-iterable/index.html">Iterable</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-explain-result-row/index.html">ExplainResultRow</a><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Represents the execution logic for an SQL statement that obtains information about a statement execution plan.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1892488068%2FClasslikes%2F-1624674168" anchor-label="ExposedConnectionImpl" id="1892488068%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-exposed-connection-impl/index.html"><span>Exposed</span><wbr><span>Connection</span><wbr><span><span>Impl</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1892488068%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-exposed-connection-impl/index.html">ExposedConnectionImpl</a> : <a href="-database-connection-auto-registration/index.html">DatabaseConnectionAutoRegistration</a></div><div class="brief "><p class="paragraph">Class responsible for the actual loading when a <a href="-database/index.html">Database</a> instance accesses a connection.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="757500515%2FClasslikes%2F-1624674168" anchor-label="Intersect" id="757500515%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-intersect/index.html"><span><span>Intersect</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="757500515%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-intersect/index.html">Intersect</a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">firstStatement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">secondStatement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span> : <a href="-set-operation/index.html">SetOperation</a></div><div class="brief "><p class="paragraph">Represents an SQL operation that returns only the common rows from two query results, without any duplicates.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1629295009%2FClasslikes%2F-1624674168" anchor-label="JdbcTransaction" id="-1629295009%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-jdbc-transaction/index.html"><span>Jdbc</span><wbr><span><span>Transaction</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1629295009%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">class </span><a href="-jdbc-transaction/index.html">JdbcTransaction</a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">transactionImpl<span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.transactions/-jdbc-transaction-interface/index.html">JdbcTransactionInterface</a></span></span><span class="token punctuation">)</span> : <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-transaction/index.html">Transaction</a>, <a href="../org.jetbrains.exposed.v1.jdbc.transactions/-jdbc-transaction-interface/index.html">JdbcTransactionInterface</a></div><div class="brief "><p class="paragraph">Class representing a unit block of work that is performed on a database using a JDBC driver.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1109247851%2FClasslikes%2F-1624674168" anchor-label="LazySizedCollection" id="-1109247851%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-lazy-sized-collection/index.html"><span>Lazy</span><wbr><span>Sized</span><wbr><span><span>Collection</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1109247851%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-lazy-sized-collection/index.html">LazySizedCollection</a><span class="token operator">&lt;</span><span class="token keyword">out </span><a href="-lazy-sized-collection/index.html">T</a><span class="token operator">&gt;</span><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">_delegate<span class="token operator">: </span><a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="-lazy-sized-collection/index.html">T</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span> : <a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="-lazy-sized-collection/index.html">T</a><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Represents a <a href="-sized-iterable/index.html">SizedIterable</a> whose elements are only loaded on first access.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1701674559%2FClasslikes%2F-1624674168" anchor-label="LazySizedIterable" id="-1701674559%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-lazy-sized-iterable/index.html"><span>Lazy</span><wbr><span>Sized</span><wbr><span><span>Iterable</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1701674559%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">interface </span><a href="-lazy-sized-iterable/index.html">LazySizedIterable</a><span class="token operator">&lt;</span><a href="-lazy-sized-iterable/index.html">T</a><span class="token operator">&gt;</span> : <a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="-lazy-sized-iterable/index.html">T</a><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Represents the iterable elements of a database result, which are stored once loaded on first access.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-687212710%2FClasslikes%2F-1624674168" anchor-label="Query" id="-687212710%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-query/index.html"><span><span>Query</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-687212710%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">class </span><a href="-query/index.html">Query</a><span class="token punctuation">(</span><span class="parameters "><span class="parameter "><span class="token keyword">var </span>set<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-field-set/index.html">FieldSet</a><span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span></span></span><span class="token punctuation">)</span> : <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><a href="-query/index.html">Query</a><span class="token operator">&gt; </span>, <a href="../org.jetbrains.exposed.v1.jdbc.statements/-blocking-executable/index.html">BlockingExecutable</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements.api/-result-api/index.html">ResultApi</a><span class="token punctuation">, </span><a href="-query/index.html">Query</a><span class="token operator">&gt; </span>, <a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-result-row/index.html">ResultRow</a><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Class representing an SQL <code class="lang-kotlin">SELECT</code> statement on which query clauses can be built.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-861847342%2FClasslikes%2F-1624674168" anchor-label="SchemaUtils" id="-861847342%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-schema-utils/index.html"><span>Schema</span><wbr><span><span>Utils</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-861847342%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">object </span><a href="-schema-utils/index.html">SchemaUtils</a> : <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-schema-utility-api/index.html">SchemaUtilityApi</a></div><div class="brief "><p class="paragraph">Utility functions that assist with creating, altering, and dropping database schema objects.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="770484379%2FClasslikes%2F-1624674168" anchor-label="SetOperation" id="770484379%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-set-operation/index.html"><span>Set</span><wbr><span><span>Operation</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="770484379%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">sealed </span><span class="token keyword">class </span><a href="-set-operation/index.html">SetOperation</a> : <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><a href="-set-operation/index.html">SetOperation</a><span class="token operator">&gt; </span>, <a href="../org.jetbrains.exposed.v1.jdbc.statements/-blocking-executable/index.html">BlockingExecutable</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements.api/-result-api/index.html">ResultApi</a><span class="token punctuation">, </span><a href="-set-operation/index.html">SetOperation</a><span class="token operator">&gt; </span>, <a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-result-row/index.html">ResultRow</a><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Represents an SQL operation that combines the results of multiple queries into a single result.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="998933889%2FClasslikes%2F-1624674168" anchor-label="SizedCollection" id="998933889%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-sized-collection/index.html"><span>Sized</span><wbr><span><span>Collection</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="998933889%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-sized-collection/index.html">SizedCollection</a><span class="token operator">&lt;</span><span class="token keyword">out </span><a href="-sized-collection/index.html">T</a><span class="token operator">&gt;</span><span class="token punctuation">(</span><span class="parameters "><span class="parameter "><span class="token keyword">val </span>delegate<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-collection/index.html">Collection</a><span class="token operator">&lt;</span><a href="-sized-collection/index.html">T</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span> : <a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="-sized-collection/index.html">T</a><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Represents a <a href="-sized-iterable/index.html">SizedIterable</a> that defers to the specified <a href="../../exposed-jdbc/org.jetbrains.exposed.v1.jdbc/-sized-collection/--root--.html">delegate</a> collection.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="427891117%2FClasslikes%2F-1624674168" anchor-label="SizedIterable" id="427891117%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-sized-iterable/index.html"><span>Sized</span><wbr><span><span>Iterable</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="427891117%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">interface </span><a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><span class="token keyword">out </span><a href="-sized-iterable/index.html">T</a><span class="token operator">&gt;</span> : <a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-iterable/index.html">Iterable</a><span class="token operator">&lt;</span><a href="-sized-iterable/index.html">T</a><span class="token operator">&gt; </span></div><div class="brief "><p class="paragraph">Represents the iterable elements of a database result.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1148731597%2FClasslikes%2F-1624674168" anchor-label="Union" id="-1148731597%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-union/index.html"><span><span>Union</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1148731597%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-union/index.html">Union</a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">firstStatement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">secondStatement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span> : <a href="-set-operation/index.html">SetOperation</a></div><div class="brief "><p class="paragraph">Represents an SQL operation that combines all results from two queries, without any duplicates.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1310836850%2FClasslikes%2F-1624674168" anchor-label="UnionAll" id="-1310836850%2FClasslikes%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="-union-all/index.html"><span>Union</span><wbr><span><span>All</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1310836850%2FClasslikes%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">class </span><a href="-union-all/index.html">UnionAll</a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">firstStatement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">secondStatement<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span> : <a href="-set-operation/index.html">SetOperation</a></div><div class="brief "><p class="paragraph">Represents an SQL operation that combines all results from two queries, with duplicates included.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <div data-togglable="EXTENSION_PROPERTY">
        <h2 class="tableheader">Properties</h2>
        <div class="table"><a data-name="-829211841%2FProperties%2F-1624674168" anchor-label="name" id="-829211841%2FProperties%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="name.html"><span><span>name</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-829211841%2FProperties%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">val </span><a href="-database/index.html">Database</a><span class="token punctuation">.</span><a href="name.html">name</a><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html">String</a></div><div class="brief "><p class="paragraph">Returns the name of the database obtained from its connection URL.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <div data-togglable="FUNCTION">
        <h2 class="tableheader">Functions</h2>
        <div class="table"><a data-name="-818765444%2FFunctions%2F-1624674168" anchor-label="andHaving" id="-818765444%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="and-having.html"><span>and</span><wbr><span><span>Having</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-818765444%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="-query/index.html">Query</a><span class="token punctuation">.</span><a href="and-having.html"><span class="token function">andHaving</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">andPart<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-query/index.html">Query</a></div><div class="brief "><p class="paragraph">Mutate Query instance and add <code class="lang-kotlin">andPart</code> to having condition with <code class="lang-kotlin">and</code> operator.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-121826900%2FFunctions%2F-1624674168" anchor-label="andWhere" id="-121826900%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="and-where.html"><span>and</span><wbr><span><span>Where</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-121826900%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="-query/index.html">Query</a><span class="token punctuation">.</span><a href="and-where.html"><span class="token function">andWhere</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">andPart<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-query/index.html">Query</a></div><div class="brief "><p class="paragraph">Mutate Query instance and add <code class="lang-kotlin">andPart</code> to where condition with <code class="lang-kotlin">and</code> operator.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-208099712%2FFunctions%2F-1624674168" anchor-label="batchInsert" id="-208099712%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="batch-insert.html"><span>batch</span><wbr><span><span>Insert</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-208099712%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-insert.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-insert.html">E</a><span class="token operator">&gt; </span><a href="batch-insert.html">T</a><span class="token punctuation">.</span><a href="batch-insert.html"><span class="token function">batchInsert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">data<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-iterable/index.html">Iterable</a><span class="token operator">&lt;</span><a href="batch-insert.html">E</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">ignore<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-batch-insert-statement/index.html">BatchInsertStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-insert.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-result-row/index.html">ResultRow</a><span class="token operator">&gt;</span></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-insert.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-insert.html">E</a><span class="token operator">&gt; </span><a href="batch-insert.html">T</a><span class="token punctuation">.</span><a href="batch-insert.html"><span class="token function">batchInsert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">data<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.sequences/-sequence/index.html">Sequence</a><span class="token operator">&lt;</span><a href="batch-insert.html">E</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">ignore<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-batch-insert-statement/index.html">BatchInsertStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-insert.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-result-row/index.html">ResultRow</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that batch inserts new rows into a table.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-366499874%2FFunctions%2F-1624674168" anchor-label="batchReplace" id="-366499874%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="batch-replace.html"><span>batch</span><wbr><span><span>Replace</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-366499874%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-replace.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-replace.html">E</a><span class="token operator"> : </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-any/index.html">Any</a><span class="token operator">&gt; </span><a href="batch-replace.html">T</a><span class="token punctuation">.</span><a href="batch-replace.html"><span class="token function">batchReplace</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">data<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-iterable/index.html">Iterable</a><span class="token operator">&lt;</span><a href="batch-replace.html">E</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-batch-replace-statement/index.html">BatchReplaceStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-replace.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-result-row/index.html">ResultRow</a><span class="token operator">&gt;</span></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-replace.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-replace.html">E</a><span class="token operator"> : </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-any/index.html">Any</a><span class="token operator">&gt; </span><a href="batch-replace.html">T</a><span class="token punctuation">.</span><a href="batch-replace.html"><span class="token function">batchReplace</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">data<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.sequences/-sequence/index.html">Sequence</a><span class="token operator">&lt;</span><a href="batch-replace.html">E</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-batch-replace-statement/index.html">BatchReplaceStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-replace.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-result-row/index.html">ResultRow</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that either batch inserts new rows into a table, or, if insertions violate unique constraints, first deletes the existing rows before inserting new rows.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1047285836%2FFunctions%2F-1624674168" anchor-label="batchUpsert" id="1047285836%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="batch-upsert.html"><span>batch</span><wbr><span><span>Upsert</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1047285836%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-upsert.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-upsert.html">E</a><span class="token operator"> : </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-any/index.html">Any</a><span class="token operator">&gt; </span><a href="batch-upsert.html">T</a><span class="token punctuation">.</span><a href="batch-upsert.html"><span class="token function">batchUpsert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">data<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-iterable/index.html">Iterable</a><span class="token operator">&lt;</span><a href="batch-upsert.html">E</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter "><span class="token keyword">vararg </span>keys<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">onUpdate<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-upsert-builder/index.html">UpsertBuilder</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">onUpdateExclude<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-batch-upsert-statement/index.html">BatchUpsertStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-upsert.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-result-row/index.html">ResultRow</a><span class="token operator">&gt;</span></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-upsert.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-upsert.html">E</a><span class="token operator"> : </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-any/index.html">Any</a><span class="token operator">&gt; </span><a href="batch-upsert.html">T</a><span class="token punctuation">.</span><a href="batch-upsert.html"><span class="token function">batchUpsert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">data<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.sequences/-sequence/index.html">Sequence</a><span class="token operator">&lt;</span><a href="batch-upsert.html">E</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter "><span class="token keyword">vararg </span>keys<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">onUpdate<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-upsert-builder/index.html">UpsertBuilder</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">onUpdateExclude<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-batch-upsert-statement/index.html">BatchUpsertStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-upsert.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-result-row/index.html">ResultRow</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that either batch inserts new rows into a table, or updates the existing rows if insertions violate unique constraints.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1947931202%2FFunctions%2F-1624674168" anchor-label="delete" id="-1947931202%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete.html"><span><span>delete</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1947931202%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-join/index.html">Join</a><span class="token punctuation">.</span><a href="delete.html"><span class="token function">delete</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">targetTable<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span></span><span class="parameter "><span class="token keyword">vararg </span>targetTables<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span></span><span class="parameter ">ignore<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes all rows from a table in a join relation.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-join/index.html">Join</a><span class="token punctuation">.</span><a href="delete.html"><span class="token function">delete</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">targetTable<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span></span><span class="parameter "><span class="token keyword">vararg </span>targetTables<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span></span><span class="parameter ">ignore<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes rows from a table in a join relation.</p></div><div class="symbol monospace"><div class="block"><div class="block"><span class="token annotation builtin">@</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.jvm/-jvm-name/index.html"><span class="token annotation builtin">JvmName</span></a><span class="token punctuation">(</span><span>name<span class="token operator"> = </span><span class="breakable-word"><span class="token string">"deleteJoinNullableParam"</span></span></span><wbr><span class="token punctuation">)</span></div></div><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-join/index.html">Join</a><span class="token punctuation">.</span><a href="delete.html"><span class="token function"><strike>delete</strike></span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">targetTable<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span></span><span class="parameter "><span class="token keyword">vararg </span>targetTables<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span></span><span class="parameter ">ignore<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="991125433%2FFunctions%2F-1624674168" anchor-label="deleteAll" id="991125433%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete-all.html"><span>delete</span><wbr><span><span>All</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="991125433%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">.</span><a href="delete-all.html"><span class="token function">deleteAll</span></a><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes all rows in a table.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-981007177%2FFunctions%2F-1624674168" anchor-label="deleteIgnoreWhere" id="-981007177%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete-ignore-where.html"><span>delete</span><wbr><span>Ignore</span><wbr><span><span>Where</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-981007177%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-ignore-where.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-ignore-where.html">T</a><span class="token punctuation">.</span><a href="delete-ignore-where.html"><span class="token function">deleteIgnoreWhere</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">op<span class="token operator">: </span><a href="delete-ignore-where.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes only rows in a table that match the provided <a href="delete-ignore-where.html">op</a>, while ignoring any possible errors that occur during the process.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="87071119%2FFunctions%2F-1624674168" anchor-label="deleteReturning" id="87071119%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete-returning.html"><span>delete</span><wbr><span><span>Returning</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="87071119%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-returning.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-returning.html">T</a><span class="token punctuation">.</span><a href="delete-returning.html"><span class="token function">deleteReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.statements/-returning-blocking-executable/index.html">ReturningBlockingExecutable</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes all rows in a table and returns specified data from the deleted rows.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-returning.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-returning.html">T</a><span class="token punctuation">.</span><a href="delete-returning.html"><span class="token function">deleteReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.statements/-returning-blocking-executable/index.html">ReturningBlockingExecutable</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes rows in a table and returns specified data from the deleted rows.</p></div><div class="symbol monospace"><div class="block"><div class="block"><span class="token annotation builtin">@</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.jvm/-jvm-name/index.html"><span class="token annotation builtin">JvmName</span></a><span class="token punctuation">(</span><span>name<span class="token operator"> = </span><span class="breakable-word"><span class="token string">"deleteReturningNullableParam"</span></span></span><wbr><span class="token punctuation">)</span></div></div><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-returning.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-returning.html">T</a><span class="token punctuation">.</span><a href="delete-returning.html"><span class="token function"><strike>deleteReturning</strike></span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.statements/-returning-blocking-executable/index.html">ReturningBlockingExecutable</a></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-2114381015%2FFunctions%2F-1624674168" anchor-label="deleteWhere" id="-2114381015%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete-where.html"><span>delete</span><wbr><span><span>Where</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-2114381015%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-where.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-where.html">T</a><span class="token punctuation">.</span><a href="delete-where.html"><span class="token function">deleteWhere</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">op<span class="token operator">: </span><a href="delete-where.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes only rows in a table that match the provided <a href="delete-where.html">op</a>.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1133153993%2FFunctions%2F-1624674168" anchor-label="emptySized" id="1133153993%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="empty-sized.html"><span>empty</span><wbr><span><span>Sized</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1133153993%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="empty-sized.html">T</a><span class="token operator">&gt; </span><a href="empty-sized.html"><span class="token function">emptySized</span></a><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="empty-sized.html">T</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Returns an <a href="-empty-sized-iterable/index.html">EmptySizedIterable</a>.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-302949104%2FFunctions%2F-1624674168" anchor-label="except" id="-302949104%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="except.html"><span><span>except</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-302949104%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">.</span><a href="except.html"><span class="token function">except</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">other<span class="token operator">: </span><a href="-query/index.html">Query</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-except/index.html">Except</a></div><div class="brief "><p class="paragraph">Returns only distinct results from <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">this</a> query that are NOT common to the results of <a href="except.html">other</a>.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="426228083%2FFunctions%2F-1624674168" anchor-label="exists" id="426228083%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="exists.html"><span><span>exists</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="426228083%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-schema/index.html">Schema</a><span class="token punctuation">.</span><a href="exists.html"><span class="token function">exists</span></a><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a></div><div class="brief "><p class="paragraph">Checks if this schema exists or not.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-sequence/index.html">Sequence</a><span class="token punctuation">.</span><a href="exists.html"><span class="token function">exists</span></a><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a></div><div class="brief "><p class="paragraph">Returns whether this sequence exists in the database.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">.</span><a href="exists.html"><span class="token function">exists</span></a><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a></div><div class="brief "><p class="paragraph">Returns whether <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">this</a> table exists in the database.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1019583520%2FFunctions%2F-1624674168" anchor-label="explain" id="-1019583520%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="explain.html"><span><span>explain</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1019583520%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="-jdbc-transaction/index.html">JdbcTransaction</a><span class="token punctuation">.</span><a href="explain.html"><span class="token function">explain</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">analyze<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">options<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html">String</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-statement-builder/index.html">StatementBuilder</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-statement/index.html">Statement</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-explain-blocking-executable/index.html">ExplainBlockingExecutable</a></div><div class="brief "><p class="paragraph">Creates an <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-explain-query/index.html">ExplainQuery</a> using the <code class="lang-kotlin">EXPLAIN</code> keyword, which obtains information about a statement execution plan.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="456445180%2FFunctions%2F-1624674168" anchor-label="insert" id="456445180%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="insert.html"><span><span>insert</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="456445180%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert.html">T</a><span class="token punctuation">.</span><a href="insert.html"><span class="token function">insert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">body<span class="token operator">: </span><a href="insert.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-number/index.html">Number</a><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-number/index.html">Number</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts a new row into a table.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert.html">T</a><span class="token punctuation">.</span><a href="insert.html"><span class="token function">insert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">selectQuery<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">columns<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that uses data retrieved from a <a href="insert.html">selectQuery</a> to insert new rows into a table.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-108799724%2FFunctions%2F-1624674168" anchor-label="insertAndGetId" id="-108799724%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="insert-and-get-id.html"><span>insert</span><wbr><span>And</span><wbr><span>Get</span><wbr><span><span>Id</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-108799724%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert-and-get-id.html">Key</a><span class="token operator"> : </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-any/index.html">Any</a><span class="token punctuation">, </span><a href="insert-and-get-id.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.dao.id/-id-table/index.html">IdTable</a><span class="token operator">&lt;</span><a href="insert-and-get-id.html">Key</a><span class="token operator">&gt;</span><span class="token operator">&gt; </span><a href="insert-and-get-id.html">T</a><span class="token punctuation">.</span><a href="insert-and-get-id.html"><span class="token function">insertAndGetId</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">body<span class="token operator">: </span><a href="insert-and-get-id.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.dao.id/-entity-i-d/index.html">EntityID</a><span class="token operator">&lt;</span><a href="insert-and-get-id.html">Key</a><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.dao.id/-entity-i-d/index.html">EntityID</a><span class="token operator">&lt;</span><a href="insert-and-get-id.html">Key</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts a new row into a table.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1090808912%2FFunctions%2F-1624674168" anchor-label="insertIgnore" id="-1090808912%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="insert-ignore.html"><span>insert</span><wbr><span><span>Ignore</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1090808912%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert-ignore.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert-ignore.html">T</a><span class="token punctuation">.</span><a href="insert-ignore.html"><span class="token function">insertIgnore</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">body<span class="token operator">: </span><a href="insert-ignore.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-builder/index.html">UpdateBuilder</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts a new row into a table, while ignoring any possible errors that occur during the process.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert-ignore.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert-ignore.html">T</a><span class="token punctuation">.</span><a href="insert-ignore.html"><span class="token function">insertIgnore</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">selectQuery<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">columns<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that uses data retrieved from a <a href="insert-ignore.html">selectQuery</a> to insert new rows into a table, while ignoring any possible errors that occur during the process.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-464767564%2FFunctions%2F-1624674168" anchor-label="insertIgnoreAndGetId" id="-464767564%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="insert-ignore-and-get-id.html"><span>insert</span><wbr><span>Ignore</span><wbr><span>And</span><wbr><span>Get</span><wbr><span><span>Id</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-464767564%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert-ignore-and-get-id.html">Key</a><span class="token operator"> : </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-any/index.html">Any</a><span class="token punctuation">, </span><a href="insert-ignore-and-get-id.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.dao.id/-id-table/index.html">IdTable</a><span class="token operator">&lt;</span><a href="insert-ignore-and-get-id.html">Key</a><span class="token operator">&gt;</span><span class="token operator">&gt; </span><a href="insert-ignore-and-get-id.html">T</a><span class="token punctuation">.</span><a href="insert-ignore-and-get-id.html"><span class="token function">insertIgnoreAndGetId</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">body<span class="token operator">: </span><a href="insert-ignore-and-get-id.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-builder/index.html">UpdateBuilder</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.dao.id/-entity-i-d/index.html">EntityID</a><span class="token operator">&lt;</span><a href="insert-ignore-and-get-id.html">Key</a><span class="token operator">&gt;</span><span class="token operator">?</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts a new row into a table, while ignoring any possible errors that occur during the process.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="449753967%2FFunctions%2F-1624674168" anchor-label="insertReturning" id="449753967%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="insert-returning.html"><span>insert</span><wbr><span><span>Returning</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="449753967%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert-returning.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert-returning.html">T</a><span class="token punctuation">.</span><a href="insert-returning.html"><span class="token function">insertReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">ignoreErrors<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="insert-returning.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-number/index.html">Number</a><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.statements/-returning-blocking-executable/index.html">ReturningBlockingExecutable</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts new rows into a table and returns specified data from the inserted rows.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-482399910%2FFunctions%2F-1624674168" anchor-label="intersect" id="-482399910%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="intersect.html"><span><span>intersect</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-482399910%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">.</span><a href="intersect.html"><span class="token function">intersect</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">other<span class="token operator">: </span><a href="-query/index.html">Query</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-intersect/index.html">Intersect</a></div><div class="brief "><p class="paragraph">Returns only results from <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">this</a> query that are common to the results of <a href="intersect.html">other</a>, WITHOUT including any duplicates.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-941189832%2FFunctions%2F-1624674168" anchor-label="mapLazy" id="-941189832%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="map-lazy.html"><span>map</span><wbr><span><span>Lazy</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-941189832%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">infix </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="map-lazy.html">T</a><span class="token punctuation">, </span><a href="map-lazy.html">R</a><span class="token operator">&gt; </span><a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="map-lazy.html">T</a><span class="token operator">&gt;</span><span class="token punctuation">.</span><a href="map-lazy.html"><span class="token function">mapLazy</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">f<span class="token operator">: </span><span class="token punctuation">(</span><a href="map-lazy.html">T</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="map-lazy.html">R</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-sized-iterable/index.html">SizedIterable</a><span class="token operator">&lt;</span><a href="map-lazy.html">R</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Returns a <a href="-sized-iterable/index.html">SizedIterable</a> containing the lazily evaluated results of applying the function <a href="map-lazy.html">f</a> to each original element.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="2012110861%2FFunctions%2F-1624674168" anchor-label="mergeFrom" id="2012110861%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="merge-from.html"><span>merge</span><wbr><span><span>From</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="2012110861%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="merge-from.html">D</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="merge-from.html">S</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="merge-from.html">D</a><span class="token punctuation">.</span><a href="merge-from.html"><span class="token function">mergeFrom</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">source<span class="token operator">: </span><a href="merge-from.html">S</a><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-merge-table-statement/index.html">MergeTableStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-merge-table-statement/index.html">MergeTableStatement</a></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="merge-from.html">D</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="merge-from.html">S</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="merge-from.html">D</a><span class="token punctuation">.</span><a href="merge-from.html"><span class="token function">mergeFrom</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">source<span class="token operator">: </span><a href="merge-from.html">S</a><span class="token punctuation">, </span></span><span class="parameter ">on<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-merge-table-statement/index.html">MergeTableStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-merge-table-statement/index.html">MergeTableStatement</a></div><div class="brief "><p class="paragraph">Performs an SQL MERGE operation to insert, update, or delete records in the target table based on a comparison with a source table.</p></div><div class="symbol monospace"><div class="block"><div class="block"><span class="token annotation builtin">@</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.jvm/-jvm-name/index.html"><span class="token annotation builtin">JvmName</span></a><span class="token punctuation">(</span><span>name<span class="token operator"> = </span><span class="breakable-word"><span class="token string">"mergeFromNullableParam"</span></span></span><wbr><span class="token punctuation">)</span></div></div><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="merge-from.html">D</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="merge-from.html">S</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="merge-from.html">D</a><span class="token punctuation">.</span><a href="merge-from.html"><span class="token function"><strike>mergeFrom</strike></span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">source<span class="token operator">: </span><a href="merge-from.html">S</a><span class="token punctuation">, </span></span><span class="parameter ">on<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-merge-table-statement/index.html">MergeTableStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-merge-table-statement/index.html">MergeTableStatement</a></div><br><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="merge-from.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="merge-from.html">T</a><span class="token punctuation">.</span><a href="merge-from.html"><span class="token function">mergeFrom</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">selectQuery<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-query-alias/index.html">QueryAlias</a><span class="token punctuation">, </span></span><span class="parameter ">on<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-merge-select-statement/index.html">MergeSelectStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-merge-select-statement/index.html">MergeSelectStatement</a></div><div class="brief "><p class="paragraph">Performs an SQL MERGE operation to insert, update, or delete records in the target table based on a comparison with a select query source.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1034854844%2FFunctions%2F-1624674168" anchor-label="orHaving" id="-1034854844%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="or-having.html"><span>or</span><wbr><span><span>Having</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1034854844%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="-query/index.html">Query</a><span class="token punctuation">.</span><a href="or-having.html"><span class="token function">orHaving</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">orPart<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-query/index.html">Query</a></div><div class="brief "><p class="paragraph">Mutate Query instance and add <code class="lang-kotlin">orPart</code> to having condition with <code class="lang-kotlin">or</code> operator.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1810865124%2FFunctions%2F-1624674168" anchor-label="orWhere" id="1810865124%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="or-where.html"><span>or</span><wbr><span><span>Where</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1810865124%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="-query/index.html">Query</a><span class="token punctuation">.</span><a href="or-where.html"><span class="token function">orWhere</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">orPart<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-query/index.html">Query</a></div><div class="brief "><p class="paragraph">Mutate Query instance and add <code class="lang-kotlin">orPart</code> to where condition with <code class="lang-kotlin">or</code> operator.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="600471356%2FFunctions%2F-1624674168" anchor-label="replace" id="600471356%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="replace.html"><span><span>replace</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="600471356%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="replace.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="replace.html">T</a><span class="token punctuation">.</span><a href="replace.html"><span class="token function">replace</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">body<span class="token operator">: </span><a href="replace.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-builder/index.html">UpdateBuilder</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-replace-statement/index.html">ReplaceStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that either inserts a new row into a table, or, if insertion would violate a unique constraint, first deletes the existing row before inserting a new row.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="replace.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="replace.html">T</a><span class="token punctuation">.</span><a href="replace.html"><span class="token function">replace</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">selectQuery<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">columns<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that uses data retrieved from a <a href="replace.html">selectQuery</a> to either insert a new row into a table, or, if insertion would violate a unique constraint, first delete the existing row before inserting a new row.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="796106075%2FFunctions%2F-1624674168" anchor-label="select" id="796106075%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="select.html"><span><span>select</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="796106075%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column-set/index.html">ColumnSet</a><span class="token punctuation">.</span><a href="select.html"><span class="token function">select</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">columns<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-query/index.html">Query</a></div><div class="brief "><p class="paragraph">Creates a <code class="lang-kotlin">SELECT</code> <a href="-query/index.html">Query</a> using a list of <a href="select.html">columns</a> or expressions from this <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column-set/index.html">ColumnSet</a>.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column-set/index.html">ColumnSet</a><span class="token punctuation">.</span><a href="select.html"><span class="token function">select</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">column<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter "><span class="token keyword">vararg </span>columns<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-query/index.html">Query</a></div><div class="brief "><p class="paragraph">Creates a <code class="lang-kotlin">SELECT</code> <a href="-query/index.html">Query</a> by selecting either a single <a href="select.html">column</a>, or a subset of <a href="select.html">columns</a>, from this <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column-set/index.html">ColumnSet</a>.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1663253974%2FFunctions%2F-1624674168" anchor-label="selectAll" id="-1663253974%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="select-all.html"><span>select</span><wbr><span><span>All</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1663253974%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-field-set/index.html">FieldSet</a><span class="token punctuation">.</span><a href="select-all.html"><span class="token function">selectAll</span></a><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-query/index.html">Query</a></div><div class="brief "><p class="paragraph">Creates a <code class="lang-kotlin">SELECT</code> <a href="-query/index.html">Query</a> by selecting all columns from this <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column-set/index.html">ColumnSet</a>.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1470271498%2FFunctions%2F-1624674168" anchor-label="union" id="1470271498%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="union.html"><span><span>union</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1470271498%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">.</span><a href="union.html"><span class="token function">union</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">other<span class="token operator">: </span><a href="-query/index.html">Query</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-union/index.html">Union</a></div><div class="brief "><p class="paragraph">Combines all results from <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">this</a> query with the results of <a href="union.html">other</a>, WITHOUT including duplicates.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-719878775%2FFunctions%2F-1624674168" anchor-label="unionAll" id="-719878775%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="union-all.html"><span>union</span><wbr><span><span>All</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-719878775%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">.</span><a href="union-all.html"><span class="token function">unionAll</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">other<span class="token operator">: </span><a href="-query/index.html">Query</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="-union-all/index.html">UnionAll</a></div><div class="brief "><p class="paragraph">Combines all results from <a href="../../exposed-core/org.jetbrains.exposed.v1.core/-abstract-query/index.html">this</a> query with the results of <a href="union-all.html">other</a>, WITH duplicates included.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-164360065%2FFunctions%2F-1624674168" anchor-label="update" id="-164360065%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="update.html"><span><span>update</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-164360065%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="update.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="update.html">T</a><span class="token punctuation">.</span><a href="update.html"><span class="token function">update</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="update.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates all rows of a table.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-join/index.html">Join</a><span class="token punctuation">.</span><a href="update.html"><span class="token function">update</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates all rows of a join relation.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="update.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="update.html">T</a><span class="token punctuation">.</span><a href="update.html"><span class="token function">update</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="update.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates rows of a table.</p></div><div class="symbol monospace"><div class="block"><div class="block"><span class="token annotation builtin">@</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.jvm/-jvm-name/index.html"><span class="token annotation builtin">JvmName</span></a><span class="token punctuation">(</span><span>name<span class="token operator"> = </span><span class="breakable-word"><span class="token string">"updateNullableParam"</span></span></span><wbr><span class="token punctuation">)</span></div></div><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="update.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="update.html">T</a><span class="token punctuation">.</span><a href="update.html"><span class="token function"><strike>update</strike></span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="update.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="symbol monospace"><div class="block"><div class="block"><span class="token annotation builtin">@</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.jvm/-jvm-name/index.html"><span class="token annotation builtin">JvmName</span></a><span class="token punctuation">(</span><span>name<span class="token operator"> = </span><span class="breakable-word"><span class="token string">"updateJoinNullableParam"</span></span></span><wbr><span class="token punctuation">)</span></div></div><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-join/index.html">Join</a><span class="token punctuation">.</span><a href="update.html"><span class="token function"><strike>update</strike></span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><br><div class="symbol monospace"><span class="token keyword">fun </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-join/index.html">Join</a><span class="token punctuation">.</span><a href="update.html"><span class="token function">update</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates rows of a join relation.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="773037856%2FFunctions%2F-1624674168" anchor-label="updateReturning" id="773037856%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="update-returning.html"><span>update</span><wbr><span><span>Returning</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="773037856%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="update-returning.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="update-returning.html">T</a><span class="token punctuation">.</span><a href="update-returning.html"><span class="token function">updateReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="update-returning.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.statements/-returning-blocking-executable/index.html">ReturningBlockingExecutable</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates all rows of a table and returns specified data from the updated rows.</p></div><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="update-returning.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="update-returning.html">T</a><span class="token punctuation">.</span><a href="update-returning.html"><span class="token function">updateReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="update-returning.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.statements/-returning-blocking-executable/index.html">ReturningBlockingExecutable</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates rows of a table and returns specified data from the updated rows.</p></div><div class="symbol monospace"><div class="block"><div class="block"><span class="token annotation builtin">@</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.jvm/-jvm-name/index.html"><span class="token annotation builtin">JvmName</span></a><span class="token punctuation">(</span><span>name<span class="token operator"> = </span><span class="breakable-word"><span class="token string">"updateReturningNullableParam"</span></span></span><wbr><span class="token punctuation">)</span></div></div><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="update-returning.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="update-returning.html">T</a><span class="token punctuation">.</span><a href="update-returning.html"><span class="token function"><strike>updateReturning</strike></span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="update-returning.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.statements/-returning-blocking-executable/index.html">ReturningBlockingExecutable</a></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1611397335%2FFunctions%2F-1624674168" anchor-label="upsert" id="-1611397335%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="upsert.html"><span><span>upsert</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1611397335%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="upsert.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="upsert.html">T</a><span class="token punctuation">.</span><a href="upsert.html"><span class="token function">upsert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter "><span class="token keyword">vararg </span>keys<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">onUpdate<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-upsert-builder/index.html">UpsertBuilder</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">onUpdateExclude<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="upsert.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-upsert-statement/index.html">UpsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-upsert-statement/index.html">UpsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that either inserts a new row into a table, or updates the existing row if insertion would violate a unique constraint.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-242753980%2FFunctions%2F-1624674168" anchor-label="upsertReturning" id="-242753980%2FFunctions%2F-1624674168" data-filterable-set=":exposed-jdbc/main"></a>
          <div class="table-row table-row_content" data-togglable="EXTENSION_FUNCTION" data-filterable-current=":exposed-jdbc/main" data-filterable-set=":exposed-jdbc/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="upsert-returning.html"><span>upsert</span><wbr><span><span>Returning</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-242753980%2FFunctions%2F-1624674168"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-jdbc/main"><div class="symbol monospace"><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="upsert-returning.html">T</a><span class="token operator"> : </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="upsert-returning.html">T</a><span class="token punctuation">.</span><a href="upsert-returning.html"><span class="token function">upsertReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter "><span class="token keyword">vararg </span>keys<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">onUpdate<span class="token operator">: </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-upsert-builder/index.html">UpsertBuilder</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">onUpdateExclude<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../exposed-core/org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="upsert-returning.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../../exposed-core/org.jetbrains.exposed.v1.core.statements/-upsert-statement/index.html">UpsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../org.jetbrains.exposed.v1.jdbc.statements/-returning-blocking-executable/index.html">ReturningBlockingExecutable</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that either inserts a new row into a table, or updates the existing row if insertion would violate a unique constraint, and also returns specified data from the modified rows.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
    <div class="footer">
        <div class="footer--container">
            <a href="#content" id="go-to-top-link" class="footer--button footer--button_go-to-top"></a>
            <div class="footer--content">
                <div>
                    <span>Generated by </span>
                    <a class="footer--link footer--link_external" href="https://github.com/Kotlin/dokka">
                        Dokka
                    </a>
                    <div>© 2025 Copyright</div>
                </div>
            </div>
        </div>
    </div>
        </div>
    </div>
</div>
</body>
</html>